package app.v1.wdt.mapper;

import app.v1.wdt.domain.pojo.WdtSalesOrder;
import com.gitee.feizns.quickstart.mybatis.plus.QuickstartBaseMapper;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;

/**
 * wdt销售订单映射器
 * @author feizns
 * @since 2023/07/19
 */
@Mapper
public interface WdtSalesOrderMapper extends QuickstartBaseMapper<WdtSalesOrder> {

    /**
     * 删除指定日期的销货单记录
     * @param date 日期
     */
    @Delete("DELETE FROM wdt_sales_order WHERE order_no LIKE CONCAT(#{date}, '%')")
    void deleteByOrderNoDate(String date);

}
